Creating calculating columns for (Full Payment, Partial Payment, No Payment) and grouping column for Class Start Date
11
creating measure in power bi using DAX

Steps Creating calculating columns for (full Payment, Partial Payment, and No Payment)
- Click on Transform data
- Press and hold control button and select FullPayPer and TotalEnr.
- Go to Add Column and click on Standard and apply math operation multiplication
- New column is created and name that "Full Payment"
- Repeat the step 2,3 PartialPayPer, NoPayPer. And give column name Partial Payment and No payment.
Follow the Gif bellow.
Grouping Class Start Date
Steps
- Click on the Data view.
- Select the column CSD
- Right click on the mouse and select New group
- Select the group type to List.
- Click on Ungrouped values and select Group
- Double click on Group member and change the format date example Jan 29 2022 to 01/29/2022. Repeat these to all dates.
Follow the Gif bellow